2014-09-29 - 13739.1300 - Spec - Report and Query changes #CrystalReportsSupport
SPECIFICATIONS
13739.1300 - Report and Query changes
Requirement Summary
Need to complete report and query changes illustrated in the project document.
Admin Info
Purpose
|
Need to complete report and query changes
|
Requested By
|
Mark Grzechowiak
|
Spec Created By
|
Uday Kumar P
|
Spec Created Date
|
09/30/2014
|
Spec QA by
|
Uday Kumar P
|
Objects
|
SA200, SA110, SA115, SA905, SA915
OSA900, OSA905, INV010 & Analysis Queries.
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
00
|
2
|
Documentation
|
08
|
3
|
Development/ Config
|
16
|
4
|
Unit test in DEV
|
08
|
5
|
Unit test in QUA
|
08
|
6
|
Other activity
|
16
|
|
TOTAL
|
56
|
References
Prior Tickets
None
Documents
reorg.docx
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
1
|
Need to change the Display property of 0MAT_SALES_0MATL_GRP5 to Text.
|
Mark Grzechowiak
|
10/07/2014
|
|
2
|
Need to replace Material SBU with 0MAT_SALES_0MATL_GRP5 in INV010 report.
|
Mark Grzechowiak
|
10/07/2014
|
|
3
|
Need to add 0MAT_SALES_0MATL_GRP5 in VDSOINVD_Q001 & change Material SBU description to Market Segment.
|
Mark Grzechowiak
|
10/09/2014
|
|
Functional Requirement
Purpose/WHY:
Need to complete changes due to an internal reorganization. New Era will be changing the way certain data is used and labeled. The primary changes will be the addition of Material Group 5(to be labeled Category) and the relabeling of the Category field(formally BU, product hierarchy level 2) to Market Segment.
In Scope:
Reports listed above.
Out of Scope:
Reports not specified in the list.
Solution Summary
1. Need to replace SBU with Navigational Material Group 5 in BEx query and change the description as Category.
2. In BEx query need to relabel the below fields i.e Product Hierarchy 2(PH2) >> Category >> Market Segment and Material Group 5 >> Category.
3. Need to replace Product Hierarchy 2 field with Material Group 5 in the report.
4. Need to add Material Group 5(to be labeled as Category) and the relabeling of the Category field(formally BU, product hierarchy level 2) to Market Segment.
5. Need to add the newly created Category field into the list of Parameters in the report.
6. Need to ensure that all labels in the report display the correct label of Category.
7. Need to check the required changes are reflected in the report.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
2
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
3
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
Solution Details
1. Need to replace SBU with Navigational Material Group 5 in BEx query and change the description as Category.
2. In BEx query need to relabel the below fields i.e Product Hierarchy 2(PH2) >> Category >> Market Segment and Material Group 5 >> Category.
3. Need to replace Product Hierarchy 2 field with Material Group 5 in the report.
4. Need to add Material Group 5(to be labeled as Category) and the relabeling of the Category field(formally BU, product hierarchy level 2) to Market Segment.
5. Need to add the newly created Category field into the list of Parameters in the report.
6. Need to ensure that all labels in the report display the correct label of Category.
7. Need to check the required changes are reflected in the report.
Issues
None